﻿


DROP USER LIDAR CASCADE;

CREATE USER LIDAR IDENTIFIED BY LIDAR;
GRANT DBA TO LIDAR;

DISCONN;
CONN LIDAR/LIDAR@192.168.4.182:1521/lvg;


--CREATE TABLE
CREATE TABLE PROJECTION(
	NAME VARCHAR2(100) PRIMARY KEY,
	BASETAB VARCHAR2(100),
	BLKTAB VARCHAR2(100),
	INPTAB VARCHAR2(100),
	RESTAB VARCHAR2(100),
	RESTST VARCHAR2(100),
	HASD1 NUMBER,
	HASD2 NUMBER,
	HASD3 NUMBER,
	HASD4 NUMBER,
	HASD5 NUMBER,
	HASD6 NUMBER,
	HASD7 NUMBER,
	HASD8 NUMBER,
	HASD9 NUMBER);

CREATE TABLE USERS(
	NAME VARCHAR2(20) PRIMARY KEY,
	PASSWORD VARCHAR(20));

--ADD ADMIN USER
INSERT INTO USERS VALUES('admin','admin'); 
INSERT INTO USERS VALUES('test','test'); 

CREATE TABLE FILECHK(
	MD5 VARCHAR2(32) PRIMARY KEY,
	TIME VARCHAR2(24),
	STATION_NAME VARCHAR(100));


COMMIT;


select  srid,  wktext from  cs_srs where wktext like '%WGS%84%Transverse Mercator%"Central_Meridian", 93.0%';

select  srid,  wktext from  cs_srs where wktext like '%WGS%84%Transverse Me
rcator%"Central_Meridian", 105.0%"False_Easting", 500000.0%"False_Northing", 0.0
%';


      SRID
----------
WKTEXT
--------------------------------------------------------------------------------

     32648
PROJCS["WGS 84 / UTM zone 48N", GEOGCS [ "WGS 84", DATUM ["World Geodetic System

 1984 (EPSG ID 6326)", SPHEROID ["WGS 84 (EPSG ID 7030)", 6378137.0, 298.2572235

63]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", 0.01745329251994

33]], PROJECTION ["Transverse Mercator"], PARAMETER ["Latitude_Of_Origin", 0.0],

 PARAMETER ["Central_Meridian", 105.0], PARAMETER ["Scale_Factor", 0.9996], PARA

METER ["False_Easting", 500000.0], PARAMETER ["False_Northing", 0.0], UNIT ["Met

er", 1.0]]






